﻿CREATE TABLE [dbo].[Entity]
(
	[entity_id] INT NOT NULL PRIMARY KEY IDENTITY, 
	[entity_type_id] INT NOT NULL, 
	[name] VARCHAR(256) NOT NULL, 
	[is_deleted] BIT NOT NULL DEFAULT 0, 
	[parent_id] INT NOT NULL DEFAULT 0, 
	[top_level_id] INT NOT NULL DEFAULT 0
)
